using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace LHS.Core.TableInfo
{
    public class InfoClinicalRecord
    {
        public const string CLRISN = "clrISN";
        public const string OLDCLRISN = "oldclrISN";
        public const string PATISN = "patISN";
        public const string EMPISN = "empISN";
        public const string CLRPULSE = "clrPulse";
        public const string CLRTEMPERATURE = "clrTemperature";
        public const string CLRBLOODPRESSURE = "clrBloodPressure";
        public const string CLRWEIGH = "clrWeigh";
        public const string CLRMEDICALHISTORY = "clrMedicalHistory";
        public const string CLRTEST = "clrTest";
        public const string CLRSICKNOTINLIST = "clrSickNotInList";
        public const string CLRPATHOLOGICALSIGNS = "clrPathologicalSigns";
        public const string CLREXAMINATIONTIMES = "clrExaminationTimes";
        public const string CLREXAMINATIONDATE = "clrExaminationDate";
        public const string CLRSKILL = "clrSkill";
        public const string CLRMEDICALADVICE = "clrMedicalAdvice";
        public const string CLRFOLLOWUPEXAMINATIONDATE = "clrFollowUpExaminationDate";
        public const string CLRDOCTORPRESCRIPTION = "clrDoctorPrescription";
        public const string CLRPICTURE = "clrPicture";
        public const string CLRSURGERY = "clrSurgery";
        public const string CLRAPPOINTMENTDATE = "clrAppointmentDate";
        public const string CLRSICKCHANGE = "clrSickChange";
        public const string CLRSICKHISTORY = "clrSickHistory";
        public const string CLRREXAMINATIONTIMES = "clrRexaminationTimes";
        public const string CLRREXAMINATIONSTATUS = "clrRexaminationStatus";
        public const string CLRPICTURESTATUS = "clrPictureStatus";
        public const string CLRTYPE = "clrType"; //edit here 20090606 1= TMH ;2 = TM
        public const string CLRREXAMINATION4SURGERY = "clrRexamination4Surgery"; // column dung de biet phau thuat nay co tai kham khong????
        public const string TABLENAME = "ClinicalRecord";

        public static DataTable GetStructure()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add(CLRISN, typeof(int));
            dt.Columns.Add(PATISN, typeof(int));
            dt.Columns.Add(EMPISN, typeof(int));
            dt.Columns.Add(CLRPULSE, typeof(decimal));
            dt.Columns.Add(CLRTEMPERATURE, typeof(string));
            dt.Columns.Add(CLRBLOODPRESSURE, typeof(string));
            dt.Columns.Add(CLRWEIGH, typeof(string));
            dt.Columns.Add(CLRMEDICALHISTORY, typeof(string));
            dt.Columns.Add(CLRTEST, typeof(string));
            dt.Columns.Add(CLRSICKNOTINLIST, typeof(string));
            dt.Columns.Add(CLRPATHOLOGICALSIGNS, typeof(string));
            dt.Columns.Add(CLREXAMINATIONTIMES, typeof(string));
            dt.Columns.Add(CLREXAMINATIONDATE, typeof(string));
            dt.Columns.Add(CLRSKILL, typeof(string));
            dt.Columns.Add(CLRMEDICALADVICE, typeof(string));
            dt.Columns.Add(CLRFOLLOWUPEXAMINATIONDATE, typeof(string));
            dt.Columns.Add(CLRDOCTORPRESCRIPTION, typeof(string));
            dt.Columns.Add(CLRPICTURE, typeof(string));
            dt.Columns.Add(CLRSURGERY, typeof(string));
            dt.Columns.Add(CLRAPPOINTMENTDATE, typeof(string));
            dt.Columns.Add(CLRSICKCHANGE, typeof(string));
            dt.Columns.Add(CLRSICKHISTORY, typeof(string));
            dt.Columns.Add(CLRREXAMINATIONTIMES, typeof(string));
            dt.Columns.Add(CLRREXAMINATIONSTATUS, typeof(string));
            dt.Columns.Add(CLRPICTURESTATUS, typeof(string));
            dt.Columns.Add(CLRREXAMINATION4SURGERY, typeof(string));
            dt.Columns.Add(CLRTYPE, typeof(short)); //edit here

            dt.TableName = TABLENAME;
            return dt;
        }

    }
}
